192
How do I display radio buttons for all cells in the column

OleObject oComboBox

oComboBox = ole_1.Object
oComboBox.Columns.Add("Radio").Def(1,true)
oComboBox.Items.AddItem(0)
oComboBox.Items.AddItem(1)

191
How do I display checkboxes for all cells in the column

OleObject oComboBox

oComboBox = ole_1.Object
oComboBox.Columns.Add("Check").Def(0,true)
oComboBox.Items.AddItem(0)
oComboBox.Items.AddItem(1)

247
How do I display as strikeout an item

OleObject oComboBox,var_Items

oComboBox = ole_1.Object
oComboBox.Columns.Add("Default")
var_Items = oComboBox.Items
	var_Items.ItemStrikeOut(var_Items.AddItem("strikeout"),true)

248
How do I display as strikeout a cell or an item

OleObject oComboBox,var_Items

oComboBox = ole_1.Object
oComboBox.Columns.Add("Default")
var_Items = oComboBox.Items
	var_Items.CellCaptionFormat(var_Items.AddItem("gets <s>strikeout</s> only a portion of text"),0,1)

249
How do I display as strikeout a cell

OleObject oComboBox,var_Items

oComboBox = ole_1.Object
oComboBox.Columns.Add("Default")
var_Items = oComboBox.Items
	var_Items.CellStrikeOut(var_Items.AddItem("strikeout"),0,true)

241
How do I display as italic an item

OleObject oComboBox,var_Items

oComboBox = ole_1.Object
oComboBox.Columns.Add("Default")
var_Items = oComboBox.Items
	var_Items.ItemItalic(var_Items.AddItem("italic"),true)

242
How do I display as italic a cell or an item

OleObject oComboBox,var_Items

oComboBox = ole_1.Object
oComboBox.Columns.Add("Default")
var_Items = oComboBox.Items
	var_Items.CellCaptionFormat(var_Items.AddItem("gets <i>italic</i> only a portion of text"),0,1)

243
How do I display as italic a cell

OleObject oComboBox,var_Items

oComboBox = ole_1.Object
oComboBox.Columns.Add("Default")
var_Items = oComboBox.Items
	var_Items.CellItalic(var_Items.AddItem("italic"),0,true)

90
How do I disable the full-row selection in the control

OleObject oComboBox

oComboBox = ole_1.Object
oComboBox.FullRowSelect = false
oComboBox.Columns.Add("Column")
oComboBox.Items.AddItem("One")
oComboBox.Items.AddItem("Two")

113
How do I disable the control

OleObject oComboBox

oComboBox = ole_1.Object
oComboBox.Enabled = false

80
How do I disable sorting the columns when clicking the control's header

OleObject oComboBox

oComboBox = ole_1.Object
oComboBox.SortOnClick = 0
oComboBox.Columns.Add("1")
oComboBox.Columns.Add("2")

81
How do I disable sorting a specified column when clicking its header

OleObject oComboBox

oComboBox = ole_1.Object
oComboBox.Columns.Add("1")
oComboBox.Columns.Add("NoSort").AllowSort = false

118
How do I disable showing the tooltip for all control
OleObject oComboBox

oComboBox = ole_1.Object
oComboBox.ToolTipDelay = 0
oComboBox.Columns.Add("tootip").ToolTip = "this is a tooltip assigned to a column"

178
How do I disable resizing a column at runtime

OleObject oComboBox

oComboBox = ole_1.Object
oComboBox.Columns.Add("Unsizable").AllowSizing = false
oComboBox.Columns.Add("C2")
oComboBox.Columns.Add("C3")
oComboBox.Columns.Add("C4")

250
How do I disable or enable an item

OleObject oComboBox,var_Items

oComboBox = ole_1.Object
oComboBox.Columns.Add("Default")
var_Items = oComboBox.Items
	var_Items.EnableItem(var_Items.AddItem("disabled"),false)
oComboBox.Items.AddItem("enabled")

179
How do I disable drag and drop columns

OleObject oComboBox

oComboBox = ole_1.Object
oComboBox.Columns.Add("C1").AllowDragging = false
oComboBox.Columns.Add("C2").AllowDragging = false

51
How do I change visual appearance of the +/- ( expand/collapse ) buttons

OleObject oComboBox,var_Items
any h

oComboBox = ole_1.Object
oComboBox.LinesAtRoot = 1
oComboBox.HasButtons = 3
oComboBox.Columns.Add("Column")
var_Items = oComboBox.Items
	h = var_Items.AddItem("Root 1")
	var_Items.InsertItem(h,,"Child 1")
	var_Items.InsertItem(h,,"Child 2")
	var_Items.ExpandItem(h,true)
	h = var_Items.AddItem("Root 2")
	var_Items.InsertItem(h,,"Child")

266
How do I change the visual effect for the cell, using your EBN files

OleObject oComboBox,var_Items
any h

oComboBox = ole_1.Object
oComboBox.VisualAppearance.Add(1,"c:\exontrol\images\normal.ebn")
oComboBox.Columns.Add("C1")
oComboBox.Columns.Add("C2")
var_Items = oComboBox.Items
	h = var_Items.AddItem("Cell 1")
	var_Items.CellCaption(h,1,"Cell 2")
	var_Items.CellBackColor(h,1,16777216 /*0x1000000*/)

147
How do I change the visual aspect only for the thumb in the scroll bar, using EBN

OleObject oComboBox

oComboBox = ole_1.Object
oComboBox.VisualAppearance.Add(1,"c:\exontrol\images\normal.ebn")
oComboBox.VisualAppearance.Add(2,"c:\exontrol\images\pushed.ebn")
oComboBox.VisualAppearance.Add(3,"c:\exontrol\images\hot.ebn")
oComboBox.Background(388,16777216 /*0x1000000*/)
oComboBox.Background(389,33554432 /*0x2000000*/)
oComboBox.Background(391,50331648 /*0x3000000*/)
oComboBox.ColumnAutoResize = false
oComboBox.Columns.Add("S").Width = 483

140
How do I change the visual aspect of the drop down filter button, using EBN

OleObject oComboBox

oComboBox = ole_1.Object
oComboBox.VisualAppearance.Add(1,"c:\exontrol\images\normal.ebn")
oComboBox.Background(0,16777216 /*0x1000000*/)
oComboBox.Columns.Add("Filter").DisplayFilterButton = true

143
How do I change the visual aspect of the drop down calendar window, that shows up if I click the drop down filter button, using EBN

OleObject oComboBox,var_Column

oComboBox = ole_1.Object
oComboBox.VisualAppearance.Add(1,"c:\exontrol\images\normal.ebn")
oComboBox.VisualAppearance.Add(2,"c:\exontrol\images\pushed.ebn")
oComboBox.Background(8,16777216 /*0x1000000*/)
oComboBox.Background(9,16777216 /*0x1000000*/)
oComboBox.Background(10,33554432 /*0x2000000*/)
oComboBox.Background(11,16777216 /*0x1000000*/)
oComboBox.Background(12,RGB(230,230,230))
oComboBox.Background(13,RGB(230,230,230))
oComboBox.Background(14,16777216 /*0x1000000*/)
var_Column = oComboBox.Columns.Add("Date")
	var_Column.FilterType = 4
	var_Column.DisplayFilterButton = true
	var_Column.DisplayFilterDate = true

142
How do I change the visual aspect of the close button in the filter bar, using EBN

OleObject oComboBox

oComboBox = ole_1.Object
oComboBox.VisualAppearance.Add(1,"c:\exontrol\images\normal.ebn")
oComboBox.Background(1,16777216 /*0x1000000*/)
oComboBox.Columns.Add("Filter").FilterType = 1
oComboBox.ApplyFilter()

144
How do I change the visual aspect of selected item in the drop down filter window, using your EBN technology

OleObject oComboBox

oComboBox = ole_1.Object
oComboBox.VisualAppearance.Add(1,"c:\exontrol\images\normal.ebn")
oComboBox.Background(20,16777216 /*0x1000000*/)
oComboBox.Background(21,RGB(255,20,20))
oComboBox.Columns.Add("Filter").DisplayFilterButton = true

141
How do I change the visual aspect of buttons in the cell, using EBN

OleObject oComboBox

oComboBox = ole_1.Object
oComboBox.VisualAppearance.Add(1,"c:\exontrol\images\normal.ebn")
oComboBox.VisualAppearance.Add(2,"c:\exontrol\images\pushed.ebn")
oComboBox.Background(2,16777216 /*0x1000000*/)
oComboBox.Background(3,33554432 /*0x2000000*/)
oComboBox.SelForeColor = RGB(0,0,0)
oComboBox.ShowFocusRect = false
oComboBox.Columns.Add("Column 1").Def(2,true)
oComboBox.Items.AddItem("Button 1")
oComboBox.Items.AddItem("Button 2")
oComboBox.Columns.Add("Column 2")

148
How do I change the visual aspect for thumb parts in the scroll bars, using EBN

OleObject oComboBox,var_Items

oComboBox = ole_1.Object
oComboBox.VisualAppearance.Add(1,"c:\exontrol\images\normal.ebn")
oComboBox.VisualAppearance.Add(2,"c:\exontrol\images\pushed.ebn")
oComboBox.VisualAppearance.Add(3,"c:\exontrol\images\hot.ebn")
oComboBox.Background(388,16777216 /*0x1000000*/)
oComboBox.Background(389,33554432 /*0x2000000*/)
oComboBox.Background(391,50331648 /*0x3000000*/)
oComboBox.Background(260,16777216 /*0x1000000*/)
oComboBox.Background(261,33554432 /*0x2000000*/)
oComboBox.Background(263,50331648 /*0x3000000*/)
oComboBox.ColumnAutoResize = false
oComboBox.ScrollBySingleLine = true
oComboBox.Columns.Add("S").Width = 483
var_Items = oComboBox.Items
	var_Items.ItemHeight(var_Items.AddItem("Item 1"),248)
oComboBox.Items.AddItem("Item 2")

236
How do I change the visual appearance for the item, using your EBN technology

OleObject oComboBox,var_Items
any h,hC

oComboBox = ole_1.Object
oComboBox.VisualAppearance.Add(1,"c:\exontrol\images\normal.ebn")
oComboBox.Columns.Add("Default")
var_Items = oComboBox.Items
	h = var_Items.AddItem("Root")
	hC = var_Items.InsertItem(h,,"Child 1")
	var_Items.ItemBackColor(hC,16777216 /*0x1000000*/)
	var_Items.InsertItem(h,,"Child 2")
	var_Items.ExpandItem(h,true)

98
How do I change the visual appearance effect for the selected item, using EBN

OleObject oComboBox

oComboBox = ole_1.Object
oComboBox.VisualAppearance.Add(1,"c:\exontrol\images\normal.ebn")
oComboBox.SelBackColor = 16777216 /*0x1000000*/
oComboBox.SelForeColor = RGB(0,0,0)
oComboBox.ShowFocusRect = false
oComboBox.Columns.Add("Column")
oComboBox.Items.AddItem(0)
oComboBox.Items.AddItem(1)

335
How do I change the text in the edit or label area

OleObject oComboBox,var_Items

oComboBox = ole_1.Object
oComboBox.Columns.Add("Column")
var_Items = oComboBox.Items
	var_Items.AddItem("Item 3")
	var_Items.AddItem("Item 1")
	var_Items.AddItem("Item 2")
oComboBox.EditText(0,"Test")

157
How do I change the item's foreground color for numbers between an interval - Range

OleObject oComboBox

oComboBox = ole_1.Object
oComboBox.ConditionalFormats.Add("%0 >= 2 and %0 <= 10").ForeColor = RGB(255,0,0)
oComboBox.Columns.Add("Numbers")
oComboBox.Items.AddItem(1)
oComboBox.Items.AddItem(2)
oComboBox.Items.AddItem(10)
oComboBox.Items.AddItem(20)

156
How do I change the item's background color for numbers less than a value

OleObject oComboBox

oComboBox = ole_1.Object
oComboBox.ConditionalFormats.Add("%0 < 10").BackColor = RGB(255,0,0)
oComboBox.Columns.Add("Numbers")
oComboBox.Items.AddItem(1)
oComboBox.Items.AddItem(2)
oComboBox.Items.AddItem(10)
oComboBox.Items.AddItem(20)

102
How do I change the height of the control's filterbar

OleObject oComboBox,var_Column

oComboBox = ole_1.Object
oComboBox.FilterBarHeight = 32
var_Column = oComboBox.Columns.Add("Column")
	var_Column.DisplayFilterButton = true
	var_Column.FilterType = 1
oComboBox.ApplyFilter()

251
How do I change the height of an item

OleObject oComboBox,var_Items

oComboBox = ole_1.Object
oComboBox.ScrollBySingleLine = true
oComboBox.Columns.Add("Default")
var_Items = oComboBox.Items
	var_Items.ItemHeight(var_Items.AddItem("height"),128)
oComboBox.Items.AddItem("enabled")

101
How do I change the header's foreground color

OleObject oComboBox

oComboBox = ole_1.Object
oComboBox.HeaderForeColor = RGB(255,0,0)
oComboBox.Columns.Add("Column 1")
oComboBox.Columns.Add("Column 2")
oComboBox.Items.AddItem("Item 1")

103
How do I change the foreground color of the control's filterbar

OleObject oComboBox,var_Column

oComboBox = ole_1.Object
oComboBox.FilterBarForeColor = RGB(255,0,0)
var_Column = oComboBox.Columns.Add("Column")
	var_Column.DisplayFilterButton = true
	var_Column.FilterType = 1
oComboBox.ApplyFilter()

237
How do I change the foreground color for the item

OleObject oComboBox,var_Items
any h,hC

oComboBox = ole_1.Object
oComboBox.Columns.Add("Default")
var_Items = oComboBox.Items
	h = var_Items.AddItem("Root")
	hC = var_Items.InsertItem(h,,"Child 1")
	var_Items.ItemForeColor(hC,RGB(255,0,0))
	var_Items.InsertItem(h,,"Child 2")
	var_Items.ExpandItem(h,true)

106
How do I change the font of the control's filterbar

OleObject oComboBox,var_Column

oComboBox = ole_1.Object
oComboBox.FilterBarFont.Size = 20
var_Column = oComboBox.Columns.Add("Column")
	var_Column.DisplayFilterButton = true
	var_Column.FilterType = 1
oComboBox.ApplyFilter()

568
How do I change the drop down filter icon/button (black)

OleObject oComboBox,var_Appearance,var_Column,var_Items

oComboBox = ole_1.Object
oComboBox.BeginUpdate()
var_Appearance = oComboBox.VisualAppearance
	var_Appearance.Add(1,"gBFLBCJwBAEHhEJAAEhABXUIQAAYAQGKIcBiAKBQAGYBIJDEMgzDDAUBjKKocQTC4AIQjCK4JDKHYJRpHEZyCA8EhqGASRAFUQBYiWE4oSpLABQaK0ZwIGyRIrkGQgQgmPYDSDNU4zVIEEglBI0TDNczhNDENgtGYaJqHIYpZBcM40TKkEZoSIITZcRrOEBiRL1S0RBhGcRUHZlWzdN64LhuK47UrWdD/XhdVzXRbjfz1Oq+bxve48Br7A5yYThdr4LhOFQ3RjIL4xbIcUwGe6VZhjOLZXjmO49T69HTtOCYBEBA")
oComboBox.Background(32,-1)
oComboBox.Background(0,16777216 /*0x1000000*/)
oComboBox.Background(26,RGB(0,0,1))
oComboBox.Background(27,RGB(255,255,255))
oComboBox.Description(25,"<bgcolor 0><fgcolor ffffff> Exclude </fgcolor></bgcolor>")
oComboBox.HeaderAppearance = 0
oComboBox.HeaderBackColor = RGB(0,0,0)
oComboBox.HeaderForeColor = RGB(255,255,255)
oComboBox.HeaderVisible = true
var_Column = oComboBox.Columns.Add("Filter")
	var_Column.FilterList = 8448 /*exShowExclude | exShowCheckBox*/
	var_Column.DisplayFilterButton = true
	var_Column.AllowSort = false
	var_Column.AllowDragging = false
var_Items = oComboBox.Items
	var_Items.AddItem("One")
	var_Items.AddItem("Two")
	var_Items.AddItem("Three")
oComboBox.EndUpdate()

86
How do I change the control's foreground color

OleObject oComboBox

oComboBox = ole_1.Object
oComboBox.ForeColor = RGB(120,120,120)
oComboBox.Columns.Add("Column")
oComboBox.Items.AddItem("item")

322
How do I change the control's border, using your EBN files

OleObject oComboBox

oComboBox = ole_1.Object
oComboBox.VisualAppearance.Add(1,"c:\exontrol\images\normal.ebn")
oComboBox.Appearance = 16777216 /*0x1000000 | */

85
How do I change the control's background color

OleObject oComboBox

oComboBox = ole_1.Object
oComboBox.BackColor = RGB(200,200,200)

87
How do I change the control's background / foreground color on the locked area

OleObject oComboBox,var_Items

oComboBox = ole_1.Object
oComboBox.CountLockedColumns = 1
oComboBox.ForeColorLock = RGB(240,240,240)
oComboBox.BackColorLock = RGB(128,128,128)
oComboBox.ColumnAutoResize = false
oComboBox.Columns.Add("Locked").Width = 128
oComboBox.Columns.Add("Un-Locked 1").Width = 128
oComboBox.Columns.Add("Un-Locked 2").Width = 128
oComboBox.Columns.Add("Un-Locked 3").Width = 128
var_Items = oComboBox.Items
	var_Items.CellCaption(var_Items.AddItem("locked"),1,"unlocked")

158
How do I change the column's foreground color for numbers between an interval - Range

OleObject oComboBox,var_ConditionalFormat,var_Items,var_Items1,var_Items2,var_Items3

oComboBox = ole_1.Object
var_ConditionalFormat = oComboBox.ConditionalFormats.Add("%0 >= 2 and %0 <= 10")
	var_ConditionalFormat.Bold = true
	var_ConditionalFormat.ForeColor = RGB(255,0,0)
	var_ConditionalFormat.ApplyTo = 1 /*0x1 | */
oComboBox.Columns.Add("N1")
oComboBox.Columns.Add("N2")
var_Items = oComboBox.Items
	var_Items.CellCaption(var_Items.AddItem(1),1,2)
var_Items1 = oComboBox.Items
	var_Items1.CellCaption(var_Items1.AddItem(3),1,3)
var_Items2 = oComboBox.Items
	var_Items2.CellCaption(var_Items2.AddItem(10),1,11)
var_Items3 = oComboBox.Items
	var_Items3.CellCaption(var_Items3.AddItem(13),1,31)
oComboBox.SearchColumnIndex = 1

175
How do I change the column's caption

OleObject oComboBox

oComboBox = ole_1.Object
oComboBox.Columns.Add("Column").Caption = "new caption"

97
How do I change the colors for the selected item

OleObject oComboBox

oComboBox = ole_1.Object
oComboBox.SelBackColor = RGB(0,0,0)
oComboBox.Columns.Add("Column")
oComboBox.Items.AddItem(0)
oComboBox.Items.AddItem(1)

267
How do I change the cell's foreground color

OleObject oComboBox,var_Items
any h

oComboBox = ole_1.Object
oComboBox.Columns.Add("C1")
oComboBox.Columns.Add("C2")
var_Items = oComboBox.Items
	h = var_Items.AddItem("Cell 1")
	var_Items.CellCaption(h,1,"Cell 2")
	var_Items.CellForeColor(h,1,RGB(255,0,0))

265
How do I change the cell's background color

OleObject oComboBox,var_Items
any h

oComboBox = ole_1.Object
oComboBox.Columns.Add("C1")
oComboBox.Columns.Add("C2")
var_Items = oComboBox.Items
	h = var_Items.AddItem("Cell 1")
	var_Items.CellCaption(h,1,"Cell 2")
	var_Items.CellBackColor(h,1,RGB(255,0,0))

264
How do I change the caption or value for a particular cell

OleObject oComboBox,var_Items

oComboBox = ole_1.Object
oComboBox.Columns.Add("C1")
oComboBox.Columns.Add("C2")
var_Items = oComboBox.Items
	var_Items.CellCaption(var_Items.AddItem("Cell 1"),1,"Cell 2")

115
How do I change the caption being displayed in the control's filter bar

OleObject oComboBox,var_Column

oComboBox = ole_1.Object
oComboBox.FilterBarCaption = "your filter caption"
var_Column = oComboBox.Columns.Add("Column")
	var_Column.DisplayFilterButton = true
	var_Column.FilterType = 1
oComboBox.ApplyFilter()

104
How do I change the background color of the control's filterbar

OleObject oComboBox,var_Column

oComboBox = ole_1.Object
oComboBox.FilterBarBackColor = RGB(240,240,240)
var_Column = oComboBox.Columns.Add("Column")
	var_Column.DisplayFilterButton = true
	var_Column.FilterType = 1
oComboBox.ApplyFilter()

235
How do I change the background color for the item

OleObject oComboBox,var_Items
any h,hC

oComboBox = ole_1.Object
oComboBox.Columns.Add("Default")
var_Items = oComboBox.Items
	h = var_Items.AddItem("Root")
	hC = var_Items.InsertItem(h,,"Child 1")
	var_Items.ItemBackColor(hC,RGB(255,0,0))
	var_Items.InsertItem(h,,"Child 2")
	var_Items.ExpandItem(h,true)

33
How do I change the "All", "Blanks" or/and "NonBlanks" caption in the drop down filter window

OleObject oComboBox

oComboBox = ole_1.Object
oComboBox.Columns.Add("Column").DisplayFilterButton = true
oComboBox.Description(0,"new name for (All)")

111
How do I call your x-script language

OleObject oComboBox,var_Column

oComboBox = ole_1.Object
var_Column = oComboBox.ExecuteTemplate("Columns.Add(`Column`)")
	var_Column.HeaderStrikeOut = true
	var_Column.HeaderBold = true

110
How do I call your x-script language

OleObject oComboBox

oComboBox = ole_1.Object
oComboBox.Template = "Columns.Add(`Column`).HTMLCaption = `<b>C</b>olumn`"

238
How do I bold an item

OleObject oComboBox,var_Items

oComboBox = ole_1.Object
oComboBox.Columns.Add("Default")
var_Items = oComboBox.Items
	var_Items.ItemBold(var_Items.AddItem("bold"),true)

239
How do I bold a cell or an item

OleObject oComboBox,var_Items

oComboBox = ole_1.Object
oComboBox.Columns.Add("Default")
var_Items = oComboBox.Items
	var_Items.CellCaptionFormat(var_Items.AddItem("gets <b>bold</b> only a portion of text"),0,1)

240
How do I bold a cell

OleObject oComboBox,var_Items

oComboBox = ole_1.Object
oComboBox.Columns.Add("Default")
var_Items = oComboBox.Items
	var_Items.CellBold(var_Items.AddItem("bold"),0,true)

233
How do I associate an extra data to an item

OleObject oComboBox,var_Items

oComboBox = ole_1.Object
oComboBox.Columns.Add("Default")
var_Items = oComboBox.Items
	var_Items.ItemData(var_Items.AddItem("item"),"your extra data")

163
How do I assign an icon to the button in the scrollbar

OleObject oComboBox

oComboBox = ole_1.Object
oComboBox.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTqlVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/yNAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=")
oComboBox.ScrollPartVisible(1,32768,true)
oComboBox.ScrollPartCaption(1,32768,"<img>1</img>")
oComboBox.ScrollHeight = 18
oComboBox.ScrollButtonWidth = 18

164
How do I assign a tooltip to a scrollbar

OleObject oComboBox

oComboBox = ole_1.Object
oComboBox.ScrollToolTip(1,"This is a tooltip being shown when you click and drag the thumb in the horizontal scroll bar")
oComboBox.ColumnAutoResize = false
oComboBox.Columns.Add("C1").Width = 256
oComboBox.Columns.Add("C2").Width = 256
oComboBox.Columns.Add("C3").Width = 256

578
How do I assign a database to your control, using ADO, ADOR or ADODB objects (MDB,JET)

OleObject oComboBox,rs

oComboBox = ole_1.Object
oComboBox.BeginUpdate()
oComboBox.ColumnAutoResize = false
rs = CREATE OLEObject
rs.ConnectToNewObject("ADOR.Recordset")
	rs.Open("Orders","Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Program Files\Exontrol\ExComboBox\Sample\Access\SAMPLE.MDB",3,3)
oComboBox.DataSource = rs
oComboBox.EndUpdate()

99
How do I assign a database to your control, using ADO, ADOR or ADODB objects

OleObject oComboBox,rs

oComboBox = ole_1.Object
oComboBox.ColumnAutoResize = false
rs = CREATE OLEObject
rs.ConnectToNewObject("ADOR.Recordset")
	rs.Open("Orders","Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Program Files\Exontrol\ExComboBox\Sample\Access\SAMPLE.MDB",3,3)
oComboBox.DataSource = rs

200
How do I arrange my columns on multiple lines

OleObject oComboBox

oComboBox = ole_1.Object
oComboBox.HeaderHeight = 32
oComboBox.Columns.Add("").HTMLCaption = "Line 1<br>Line 2"

201
How do I arrange my columns on multiple levels

OleObject oComboBox

oComboBox = ole_1.Object
oComboBox.Columns.Add("S").Width = 32
oComboBox.Columns.Add("Level 2").LevelKey = 1
oComboBox.Columns.Add("Level 3").LevelKey = 1
oComboBox.Columns.Add("Level 4").LevelKey = 1
oComboBox.Columns.Add("Level 1").LevelKey = "2"
oComboBox.Columns.Add("Level 2").LevelKey = "2"
oComboBox.Columns.Add("Level 3").LevelKey = "2"
oComboBox.Columns.Add("Level 4").LevelKey = "2"
oComboBox.Columns.Add("E").Width = 32

303
How do I apply HTML format to a cell

OleObject oComboBox,var_Items
any h

oComboBox = ole_1.Object
oComboBox.TreeColumnIndex = -1
oComboBox.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTqlVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/yNAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=")
oComboBox.HTMLPicture("p1","c:\exontrol\images\zipdisk.gif")
oComboBox.HTMLPicture("p2","c:\exontrol\images\auction.gif")
oComboBox.Columns.Add("Default")
var_Items = oComboBox.Items
	h = var_Items.AddItem("The following item shows some of the HTML format supported:")
	var_Items.CellHAlignment(h,0,1)
	h = var_Items.AddItem("<br>text icons <img>1</img>, <img>2</img>, ... pictures <img>p1</img>, <img>p2</img> <br><br>text <b>bold</b>, <i>italic</i>, <u>underline</u>, <s>strikeout</s>, ...<br><dotline>and so on...<br> <a>anchor</a> or <a2>hyperlink</a><br><fgcolor=FF0000>fgcolor</fgcolor> or <bgcolor=00FF00>bgcolor</bgcolor> ")
	var_Items.CellCaptionFormat(h,0,1)
	var_Items.CellSingleLine(h,0,false)

182
How do I align the icon in the column's header to the right

OleObject oComboBox,var_Column

oComboBox = ole_1.Object
oComboBox.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTqlVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/yNAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=")
var_Column = oComboBox.Columns.Add("ColumnName")
	var_Column.HeaderImage = 1
	var_Column.HeaderImageAlignment = 2

346
How do change the visual appearance for the drop down border, using EBN

OleObject oComboBox

oComboBox = ole_1.Object
oComboBox.VisualAppearance.Add(1,"c:\exontrol\images\normal.ebn")
oComboBox.DropDownBorder = 16777216 /*0x1000000 | */

70
How do change the visual appearance for the control's header bar, using EBN

OleObject oComboBox

oComboBox = ole_1.Object
oComboBox.VisualAppearance.Add(1,"c:\exontrol\images\normal.ebn")
oComboBox.HeaderBackColor = 16777216 /*0x1000000*/

197
How do change the vertical alignment for all cells in the column

OleObject oComboBox,var_Items,var_Items1

oComboBox = ole_1.Object
oComboBox.Columns.Add("MultipleLine").Def(16,false)
oComboBox.Columns.Add("VAlign").Def(6,2)
var_Items = oComboBox.Items
	var_Items.CellCaption(var_Items.AddItem("This is a bit of long text that should break the line"),1,"bottom")
var_Items1 = oComboBox.Items
	var_Items1.CellCaption(var_Items1.AddItem("This is a bit of long text that should break the line"),1,"bottom")

196
How do change the foreground color for all cells in the column

OleObject oComboBox

oComboBox = ole_1.Object
oComboBox.Columns.Add("ForeColor").Def(5,255)
oComboBox.Items.AddItem(0)
oComboBox.Items.AddItem(1)

195
How do change the background color for all cells in the column

OleObject oComboBox

oComboBox = ole_1.Object
oComboBox.Columns.Add("BackColor").Def(4,255)
oComboBox.Items.AddItem(0)
oComboBox.Items.AddItem(1)

5
How can I use HTML format in column's header

OleObject oComboBox

oComboBox = ole_1.Object
oComboBox.Columns.Add("ColumnName").HTMLCaption = "<b>HTML</b> <fgcolor=0000FF>Col</fgcolor>umn"

28
How can I underline the column's header

OleObject oComboBox

oComboBox = ole_1.Object
oComboBox.Columns.Add("Column 1").HeaderUnderline = true

213
How can I underline all cells in the column

OleObject oComboBox,var_ConditionalFormat

oComboBox = ole_1.Object
var_ConditionalFormat = oComboBox.ConditionalFormats.Add("1")
	var_ConditionalFormat.Underline = true
	var_ConditionalFormat.ApplyTo = 0
oComboBox.Columns.Add("Column")
oComboBox.Items.AddItem(0)
oComboBox.Items.AddItem(1)

185
How can I specify the minimum width for the column, if I use WidthAutoResize property

OleObject oComboBox,var_Column

oComboBox = ole_1.Object
var_Column = oComboBox.Columns.Add("Auto")
	var_Column.WidthAutoResize = true
	var_Column.MinWidthAutoResize = 32
oComboBox.Items.AddItem(0)
oComboBox.Items.AddItem(1)

186
How can I specify the maximum width for the column, if I use WidthAutoResize property

OleObject oComboBox,var_Column

oComboBox = ole_1.Object
var_Column = oComboBox.Columns.Add("Auto")
	var_Column.WidthAutoResize = true
	var_Column.MinWidthAutoResize = 32
	var_Column.MaxWidthAutoResize = 128
oComboBox.Items.AddItem(0)
oComboBox.Items.AddItem(1)

441
How can I specify the format for negative numbers

OleObject oComboBox,var_Items
any h

oComboBox = ole_1.Object
oComboBox.BeginUpdate()
oComboBox.Columns.Add("Def").Def(17,1)
var_Items = oComboBox.Items
	h = var_Items.AddItem(-100000.27)
	var_Items.FormatCell(h,0,"(value format '') +  ' <fgcolor=808080>(default)'")
	h = var_Items.AddItem(-100000.27)
	var_Items.FormatCell(h,0,"(value format '||||1') +  ' <fgcolor=808080>(Negative sign, number; for example, -1.1)'")
oComboBox.EndUpdate()

432
How can I specify an item to be always the last item

OleObject oComboBox,var_Items
any h

oComboBox = ole_1.Object
oComboBox.BeginUpdate()
oComboBox.TreeColumnIndex = -1
oComboBox.Columns.Add("Numbers").SortType = 1
var_Items = oComboBox.Items
	var_Items.AddItem(1)
	var_Items.AddItem(2)
	var_Items.AddItem(3)
	var_Items.AddItem(4)
	h = var_Items.AddItem("last")
	var_Items.CellHAlignment(h,0,2)
	var_Items.SortableItem(h,false)
	var_Items.SortChildren(0,0,true)
oComboBox.EndUpdate()

433
How can I specify an item to be always the first item

OleObject oComboBox,var_Items
any h

oComboBox = ole_1.Object
oComboBox.BeginUpdate()
oComboBox.TreeColumnIndex = -1
oComboBox.Columns.Add("Numbers").SortType = 1
var_Items = oComboBox.Items
	var_Items.AddItem(1)
	var_Items.AddItem(2)
	var_Items.AddItem(3)
	var_Items.AddItem(4)
	h = var_Items.AddItem("first")
	var_Items.ItemPosition(h,0)
	var_Items.CellHAlignment(h,0,2)
	var_Items.SortableItem(h,false)
	var_Items.SortChildren(0,0,false)
oComboBox.EndUpdate()

530
How can I specify alternate background colors for each root item, similar with BackColorAlternate

OleObject oComboBox,var_Column,var_Column1,var_ConditionalFormat,var_Items
any h

oComboBox = ole_1.Object
oComboBox.BeginUpdate()
oComboBox.LinesAtRoot = -1
var_Column = oComboBox.Columns.Add("Default")
	var_Column.Def(0,true)
	var_Column.PartialCheck = true
var_Column1 = oComboBox.Columns.Add("Position")
	var_Column1.FormatColumn = "( ( 1:=( ( 0:=(1 rpos '') ) lfind `.`) ) < 0 ? =:0 : (=:0 left =:1) )"
	var_Column1.Visible = false
var_ConditionalFormat = oComboBox.ConditionalFormats.Add("%C1 mod 2")
	var_ConditionalFormat.BackColor = RGB(240,240,240)
var_Items = oComboBox.Items
	h = var_Items.AddItem("Root 1")
	var_Items.InsertItem(h,,"Child 1")
	var_Items.InsertItem(h,,"Child 2")
	var_Items.ExpandItem(h,true)
	h = var_Items.AddItem("Root 2")
	var_Items.InsertItem(h,,"Child 1")
	var_Items.InsertItem(h,,"Child 2")
	h = var_Items.AddItem("Root 3")
	var_Items.InsertItem(h,,"Child 1")
	var_Items.InsertItem(h,,"Child 2")
oComboBox.EndUpdate()

355
How can I sort the value gets listed in the drop down filter window

OleObject oComboBox,var_Column,var_Column1,var_Items
any h

oComboBox = ole_1.Object
oComboBox.LinesAtRoot = -1
oComboBox.MarkSearchColumn = false
oComboBox.Description(0,"")
oComboBox.Description(1,"")
oComboBox.Description(2,"")
var_Column = oComboBox.Columns.Add("P1")
	var_Column.DisplayFilterButton = true
	var_Column.DisplayFilterPattern = false
	var_Column.FilterList = 16
var_Column1 = oComboBox.Columns.Add("P2")
	var_Column1.DisplayFilterButton = true
	var_Column1.DisplayFilterPattern = false
	var_Column1.FilterList = 32
var_Items = oComboBox.Items
	h = var_Items.AddItem("Z3")
	var_Items.CellCaption(h,1,"C")
	var_Items.CellCaption(var_Items.InsertItem(h,,"Z1"),1,"B")
	var_Items.CellCaption(var_Items.InsertItem(h,,"Z2"),1,"A")
	var_Items.ExpandItem(h,true)

230
How can I sort the items

OleObject oComboBox,var_Items
any h

oComboBox = ole_1.Object
oComboBox.Columns.Add("Default")
var_Items = oComboBox.Items
	h = var_Items.AddItem("Root")
	var_Items.InsertItem(h,,"Child 1")
	var_Items.InsertItem(h,,"Child 2")
	var_Items.ExpandItem(h,true)
oComboBox.Columns.Item("Default").SortOrder = 2

136
How can I sort by multiple columns

OleObject oComboBox

oComboBox = ole_1.Object
oComboBox.SingleSort = false
oComboBox.Columns.Add("C1").SortOrder = 1
oComboBox.Columns.Add("C2").SortOrder = 2
oComboBox.Columns.Add("C3").SortOrder = 1

434
How can I simulate displaying groups

OleObject oComboBox,var_Columns,var_Items
any h,h1

oComboBox = ole_1.Object
oComboBox.HasLines = 0
oComboBox.ScrollBySingleLine = true
var_Columns = oComboBox.Columns
	var_Columns.Add("Name")
	var_Columns.Add("A")
	var_Columns.Add("B")
	var_Columns.Add("C")
var_Items = oComboBox.Items
	h = var_Items.AddItem("Group 1")
	var_Items.CellHAlignment(h,0,1)
	var_Items.ItemDivider(h,0)
	var_Items.ItemDividerLineAlignment(h,3)
	var_Items.ItemHeight(h,24)
	var_Items.SortableItem(h,false)
	h1 = var_Items.InsertItem(h,,"Child 1")
	var_Items.CellCaption(h1,1,1)
	var_Items.CellCaption(h1,2,2)
	var_Items.CellCaption(h1,3,3)
	h1 = var_Items.InsertItem(h,,"Child 2")
	var_Items.CellCaption(h1,1,4)
	var_Items.CellCaption(h1,2,5)
	var_Items.CellCaption(h1,3,6)
	var_Items.ExpandItem(h,true)
	h = var_Items.AddItem("Group 2")
	var_Items.CellHAlignment(h,0,1)
	var_Items.ItemDivider(h,0)
	var_Items.ItemDividerLineAlignment(h,3)
	var_Items.ItemHeight(h,24)
	var_Items.SortableItem(h,false)
	h1 = var_Items.InsertItem(h,,"Child 1")
	var_Items.CellCaption(h1,1,1)
	var_Items.CellCaption(h1,2,2)
	var_Items.CellCaption(h1,3,3)
	h1 = var_Items.InsertItem(h,,"Child 2")
	var_Items.CellCaption(h1,1,4)
	var_Items.CellCaption(h1,2,5)
	var_Items.CellCaption(h1,3,6)
	var_Items.ExpandItem(h,true)

128
How can I show the locked / fixed items on the bottom side of the control

OleObject oComboBox,var_Items

oComboBox = ole_1.Object
oComboBox.ShowLockedItems = true
oComboBox.Columns.Add("Column")
var_Items = oComboBox.Items
	var_Items.LockedItemCount(1,2)
	var_Items.CellCaption(var_Items.LockedItem(1,0),0,"locked item 1")
	var_Items.CellCaption(var_Items.LockedItem(1,1),0,"locked item 2")
	var_Items.AddItem("un-locked item")

127
How can I show the locked / fixed items

OleObject oComboBox,var_Items

oComboBox = ole_1.Object
oComboBox.ShowLockedItems = true
oComboBox.Columns.Add("Column")
var_Items = oComboBox.Items
	var_Items.LockedItemCount(0,2)
	var_Items.CellCaption(var_Items.LockedItem(0,0),0,"locked item 1")
	var_Items.CellCaption(var_Items.LockedItem(0,1),0,"locked item 2")
	var_Items.AddItem("un-locked item")

336
How can I show the drop down window as soon as user starts typing in the control

OleObject oComboBox,var_Items

oComboBox = ole_1.Object
oComboBox.AutoDropDown = true
oComboBox.Columns.Add("Column")
var_Items = oComboBox.Items
	var_Items.AddItem("Item 3")
	var_Items.AddItem("Item 1")
	var_Items.AddItem("Item 2")

125
How can I show the control's sort bar

OleObject oComboBox

oComboBox = ole_1.Object
oComboBox.SortBarVisible = true

55
How can I show the control's grid lines only for added/visible items

OleObject oComboBox

oComboBox = ole_1.Object
oComboBox.MarkSearchColumn = false
oComboBox.DrawGridLines = -2
oComboBox.Columns.Add("Column 1")
oComboBox.Columns.Add("Column 2")
oComboBox.Items.AddItem(0)
oComboBox.Items.AddItem(1)
oComboBox.Items.AddItem(2)

17
How can I show the control's grid lines

OleObject oComboBox

oComboBox = ole_1.Object
oComboBox.MarkSearchColumn = false
oComboBox.DrawGridLines = -1
oComboBox.Columns.Add("Column 1")
oComboBox.Columns.Add("Column 2")
oComboBox.Items.AddItem(0)
oComboBox.Items.AddItem(1)
oComboBox.Items.AddItem(2)

449
How can I show the child items with no identation

OleObject oComboBox,var_Items
any h

oComboBox = ole_1.Object
oComboBox.LinesAtRoot = 5
oComboBox.Indent = 12
oComboBox.HasLines = 2
oComboBox.Columns.Add("Default")
var_Items = oComboBox.Items
	h = var_Items.AddItem("Root 1")
	var_Items.InsertItem(h,,"Child 1")
	var_Items.InsertItem(h,,"Child 2")
	var_Items.InsertItem(h,,"Child 3")
	var_Items.ExpandItem(h,true)
	h = var_Items.AddItem("Root 2")
	var_Items.InsertItem(h,,"Child 1")
	var_Items.InsertItem(h,,"Child 2")
	var_Items.InsertItem(h,,"Child 3")

12
How can I show or hide a column

OleObject oComboBox

oComboBox = ole_1.Object
oComboBox.Columns.Add("Hidden").Visible = false

204
How can I show or display the control's filter

OleObject oComboBox

oComboBox = ole_1.Object
oComboBox.Columns.Add("Filter").DisplayFilterButton = true

480
How can I show only the matching items, while user types in the drop down control

/*begin event EditChange(long  ColIndex) - Fired when the user has taken an action that may have altered text in an edit control.*/
/*
	OleObject var_Items
	any sLabel
	oComboBox = ole_1.Object
	sLabel = oComboBox.EditText(ColIndex)
	MessageBox("Information",string( "Select the item that maches exactly the typing label: " ))
	MessageBox("Information",string( String(sLabel) ))
	var_Items = oComboBox.Items
		var_Items.SelectItem(var_Items.FocusItem,false)
		var_Items.SelectItem(var_Items.FindItem(sLabel,ColIndex),true)
*/
/*end event EditChange*/

OleObject oComboBox,var_Items

oComboBox = ole_1.Object
oComboBox.BeginUpdate()
oComboBox.SingleEdit = true
oComboBox.AutoComplete = false
oComboBox.AutoSelect = false
oComboBox.AutoSearch = false
oComboBox.AutoDropDown = true
oComboBox.IntegralHeight = true
oComboBox.HeaderVisible = false
oComboBox.Columns.Add("Friends")
var_Items = oComboBox.Items
	var_Items.AddItem("Fred")
	var_Items.AddItem("Tina")
	var_Items.AddItem("Tom")
oComboBox.EndUpdate()

212
How can I show in italic all data in the column

OleObject oComboBox,var_ConditionalFormat

oComboBox = ole_1.Object
var_ConditionalFormat = oComboBox.ConditionalFormats.Add("1")
	var_ConditionalFormat.Italic = true
	var_ConditionalFormat.ApplyTo = 0
oComboBox.Columns.Add("Column")
oComboBox.Items.AddItem(0)
oComboBox.Items.AddItem(1)

214
How can I show as strikeout all cells in the column

OleObject oComboBox,var_ConditionalFormat

oComboBox = ole_1.Object
var_ConditionalFormat = oComboBox.ConditionalFormats.Add("1")
	var_ConditionalFormat.StrikeOut = true
	var_ConditionalFormat.ApplyTo = 0
oComboBox.Columns.Add("Column")
oComboBox.Items.AddItem(0)
oComboBox.Items.AddItem(1)

208
How can I show a column that adds values in the cells

OleObject oComboBox,var_Items,var_Items1

oComboBox = ole_1.Object
oComboBox.Columns.Add("A")
oComboBox.Columns.Add("B")
oComboBox.Columns.Add("A+B").ComputedField = "%0 + %1"
var_Items = oComboBox.Items
	var_Items.CellCaption(var_Items.AddItem(1),1,2)
var_Items1 = oComboBox.Items
	var_Items1.CellCaption(var_Items1.AddItem(10),1,20)

600
How can I replace or add an icon at runtime

OleObject oComboBox

oComboBox = ole_1.Object
oComboBox.BeginUpdate()
oComboBox.ReplaceIcon("gAAAABgYACEHgUJFEEAAWhUJCEJEEJggEhMCYEXjUbjkJQECj8gj8hAEjkshYEpk8kf8ClsulsvAExmcvf83js5nU7nkCeEcn8boMaocXosCB9Hn09pkzcEuoL/fE+OkYB0gB9YhIHrddgVcr9aktZADAD8+P8CgIA==")
oComboBox.ReplaceIcon("C:\images\favicon.ico",0)
oComboBox.Columns.Add("Items").Def(17,1)
oComboBox.Items.AddItem("Item <img>1</img>")
oComboBox.EndUpdate()

350
How can I remove the filter

OleObject oComboBox,var_Column

oComboBox = ole_1.Object
var_Column = oComboBox.Columns.Add("Column")
	var_Column.DisplayFilterButton = true
	var_Column.FilterType = 1
oComboBox.ApplyFilter()
oComboBox.ClearFilter()

227
How can I remove or delete an item

OleObject oComboBox
any h

oComboBox = ole_1.Object
oComboBox.Columns.Add("Default")
h = oComboBox.Items.AddItem("removed item")
oComboBox.Items.RemoveItem(h)

228
How can I remove or delete all items

OleObject oComboBox

oComboBox = ole_1.Object
oComboBox.Columns.Add("Default")
oComboBox.Items.AddItem("removed item")
oComboBox.Items.RemoveAllItems()